Configuring Database Systems
نویسنده
چکیده
This paper provides the system administrator with a fundamental understanding of database architecture internals so that he can better configure relational database systems. The topics of discussion include buffer management, access methods, and lock management. To both illustrate concepts in practice, and to contrast the two architectures of market leaders, Oracle and Sybase implementations are referenced throughout the paper. The paper describes different backup strategies and when each strategy is appropriate. In conclusion, the paper describes special hardware considerations for high availability and performance of database systems.
منابع مشابه
Configuring buffer pools in DB2 UDB
Database Management Systems (DBMSs) use a main memory area as a buffer to reduce the number of disk accesses performed by a transaction. DB2 Universal Database divides the buffer area into a number of independent buffer pools and each database object (table or index) is assigned to a specific buffer pool. The tasks of configuring the buffer pools, which defines the mapping of database objects t...
متن کاملSODDA - A Service-Oriented Distributed Database Architecture
The dissemination of information systems over computer networks has reinforced the interest on distributed database management systems (DDBMS). A review on the architecture of such systems is motivated by the wide availability of networking resources, which allows the cost of communication among the nodes to be reduced. Besides, the coming of age of syntactic interoperability standards, such as...
متن کاملGrid Data Management Distributed Database Management and Replication with Object Granularity
In the context of the ALDAP (Accessing Large Data Archives in Astrophysics and Particle Physics) project funded by the NSF KDI program, we are collaborating with the SDSS Science Archive team at JHU [1] to exchange knowledge and experience in in implementing large science archives using Objectivity/DB. The JHU group has extensive experience in database structures, optimizing database queries, a...
متن کاملRfc 3814 Mpls Ftn
This memo defines a portion of the Management Information Base (MIB) for use with network management protocols in the Internet community. In particular, it describes managed objects for defining, configuring, and monitoring Forwarding Equivalence Class (FEC) to Next Hop Label Forwarding Entry (NHLFE) mappings and corresponding actions for use with Multiprotocol Label Switching (MPLS).
متن کاملRFC 7184 The OLSRv 2 - MIB
This document defines the Management Information Base (MIB) module for configuring and managing the Optimized Link State Routing Protocol version 2 (OLSRv2). The OLSRv2-MIB module is structured into configuration information, state information, performance information, and notifications. This additional state and performance information is useful for troubleshooting problems and performance iss...
متن کامل